Quản lý website giới thiệu và bán điện thoại di động ASP.net
19.324 lượt xem;
- chitiet.aspx.cs
- project /
1 using System;
2 using System.Data;
3 using System.Configuration;
4 using System.Collections;
5 using System.Web;
6 using System.Web.Security;
7 using System.Web.UI;
8 using System.Web.UI.WebControls;
9 using System.Web.UI.WebControls.WebParts;
10 using System.Web.UI.HtmlControls;
11 using System.Data.OleDb;
12
13 public partial class Default3 : System.Web.UI.Page
14 {
15 DataTable dt; GioHangData gh;
16 protected void Page_Load(object sender, EventArgs e)
17 {
18
19 ado.ketNoi();
20 string query = "SELECT * FROM tblSanPham where tensp='" + Request.QueryString.Get("tensp") + "'";
21 ado.rd = ado.getData(query);
22 if (ado.rd.Read())
23 {
24 lblTenSP.Text = ado.rd["TenSP"].ToString();
25 lblMoTa.Text = ado.rd["dacdiem"].ToString();
26
27 lbbh.Text += ado.rd["Baohanh"].ToString();
28
29 lblGia.Text = ado.rd["Gia"].ToString();
30
31 if (Convert.ToDouble(ado.rd["soluong"]) > 0)
32 {
33 lblKho.Text = "Còn hàng";
34 }
35 else
36 {
37 lblKho.Text = "Hết hàng";
38 }
39 lblkm.Text = ado.rd["khuyenmai"].ToString();
40 imgSP.ImageUrl = "dienthoai/" + ado.rd["Anh"].ToString();
41 }
42 }
43
44 protected void ImageButton2_Click(object sender, ImageClickEventArgs e)
45 {
46 //gh = new GioHangData();
47 //DataTable tb;
48 //if (Session["GioHang"] == null)
49 // tb = gh.setTable();
50 //else
51 // tb = (DataTable)Session["GioHang"];
52 //string query = "select * from tblSanPham where masp='" + lblTenSP.Text + "'";
53
54 //OleDbDataAdapter da = new OleDbDataAdapter(query, ado.con);
55 //DataTable dt = new DataTable();
56 //da.Fill(dt);
57 //foreach (DataRow dr in dt.Rows)
58 //{
59 // tb = gh.dienVaoBang(tb, dr[10].ToString(), dr["TenSP"].ToString(), 1, Convert.ToDouble(dr["Gia"]), dr["masp"].ToString());
60 // Session["GioHang"] = tb;
61
62 //}
63 }
64 protected void ImageButton2_Command(object sender, CommandEventArgs e)
65 {
66 gh = new GioHangData();
67 DataTable tb;
68 if (Session["GioHang"] == null)
69 tb = gh.setTable();
70 else
71 tb = (DataTable)Session["GioHang"];
72 string query = "select * from tblSanPham where masp='" + lblTenSP.Text + "'";
73
74 OleDbDataAdapter da = new OleDbDataAdapter(query, ado.con);
75 DataTable dt = new DataTable();
76 da.Fill(dt);
77 foreach (DataRow dr in dt.Rows)
78 {
79 tb = gh.dienVaoBang(tb, dr[10].ToString(), dr["TenSP"].ToString(), 1, Convert.ToDouble(dr["Gia"]), dr["masp"].ToString());
80 Session["GioHang"] = tb;
81 //Download source code tại Sharecode.vn
82 }
83 }
84 }
2 using System.Data;
3 using System.Configuration;
4 using System.Collections;
5 using System.Web;
6 using System.Web.Security;
7 using System.Web.UI;
8 using System.Web.UI.WebControls;
9 using System.Web.UI.WebControls.WebParts;
10 using System.Web.UI.HtmlControls;
11 using System.Data.OleDb;
12
13 public partial class Default3 : System.Web.UI.Page
14 {
15 DataTable dt; GioHangData gh;
16 protected void Page_Load(object sender, EventArgs e)
17 {
18
19 ado.ketNoi();
20 string query = "SELECT * FROM tblSanPham where tensp='" + Request.QueryString.Get("tensp") + "'";
21 ado.rd = ado.getData(query);
22 if (ado.rd.Read())
23 {
24 lblTenSP.Text = ado.rd["TenSP"].ToString();
25 lblMoTa.Text = ado.rd["dacdiem"].ToString();
26
27 lbbh.Text += ado.rd["Baohanh"].ToString();
28
29 lblGia.Text = ado.rd["Gia"].ToString();
30
31 if (Convert.ToDouble(ado.rd["soluong"]) > 0)
32 {
33 lblKho.Text = "Còn hàng";
34 }
35 else
36 {
37 lblKho.Text = "Hết hàng";
38 }
39 lblkm.Text = ado.rd["khuyenmai"].ToString();
40 imgSP.ImageUrl = "dienthoai/" + ado.rd["Anh"].ToString();
41 }
42 }
43
44 protected void ImageButton2_Click(object sender, ImageClickEventArgs e)
45 {
46 //gh = new GioHangData();
47 //DataTable tb;
48 //if (Session["GioHang"] == null)
49 // tb = gh.setTable();
50 //else
51 // tb = (DataTable)Session["GioHang"];
52 //string query = "select * from tblSanPham where masp='" + lblTenSP.Text + "'";
53
54 //OleDbDataAdapter da = new OleDbDataAdapter(query, ado.con);
55 //DataTable dt = new DataTable();
56 //da.Fill(dt);
57 //foreach (DataRow dr in dt.Rows)
58 //{
59 // tb = gh.dienVaoBang(tb, dr[10].ToString(), dr["TenSP"].ToString(), 1, Convert.ToDouble(dr["Gia"]), dr["masp"].ToString());
60 // Session["GioHang"] = tb;
61
62 //}
63 }
64 protected void ImageButton2_Command(object sender, CommandEventArgs e)
65 {
66 gh = new GioHangData();
67 DataTable tb;
68 if (Session["GioHang"] == null)
69 tb = gh.setTable();
70 else
71 tb = (DataTable)Session["GioHang"];
72 string query = "select * from tblSanPham where masp='" + lblTenSP.Text + "'";
73
74 OleDbDataAdapter da = new OleDbDataAdapter(query, ado.con);
75 DataTable dt = new DataTable();
76 da.Fill(dt);
77 foreach (DataRow dr in dt.Rows)
78 {
79 tb = gh.dienVaoBang(tb, dr[10].ToString(), dr["TenSP"].ToString(), 1, Convert.ToDouble(dr["Gia"]), dr["masp"].ToString());
80 Session["GioHang"] = tb;
81 //Download source code tại Sharecode.vn
82 }
83 }
84 }